package com.example.javaeefinal.Mapper;

import com.example.javaeefinal.pojo.Good;
import org.apache.ibatis.annotations.Select;

/**
 * @Auther: Lai Wenhao
 * @Date: 2023/12/27 20:27
 **/
public interface GoodMapper {
    //    查找实体信息
    @Select("SELECT f_goodId AS id,\n" +
            "       f_goodName AS goodName,\n" +
            "       f_supplierId AS supplierId,\n" +
            "       f_price AS price\n" +
            "FROM t_goodinfo\n" +
            "WHERE f_goodId=#{ID};")
    Good getGoodById(int id);
}
